[dbo].[BAECartOrderGetForUserByProductCode]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAECartOrderGetForUserByProductCode

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@UserId	varchar(32)	32
@OrderProductId	int	4

SQL Script

create procedure [dbo].[BAECartOrderGetForUserByProductCode] @UserId varchar(32),
     @OrderProductId int as
SELECT co.CartOrderID
    FROM CartOrder co
    INNER JOIN CartItem ci on ci.CartItemID = co.CartItemID
    WHERE ci.UserID = @UserId
        AND co.OrderProductID = @OrderProductId

GO

Uses

[dbo].[CartItem]
[dbo].[CartOrder]
dbo